Mastering Perplexity AI: A Quick Guide to Copying and Using Tables

Table of Contents

Perplexity AI is revolutionizing the way we access and utilize information by integrating the power of generative artificial intelligence directly into search functionalities. This innovative approach allows users to obtain answers that are not only more precise but also meticulously compiled, going beyond simple lists of links. One of the most compelling features of Perplexity AI is its ability to structure data according to user needs, presenting information in various organized formats such as tables, lists, and bullet points. This capability is especially useful when dealing with complex data sets or when needing to compare and contrast information efficiently. In this guide, we will delve into the straightforward process of copying tables generated by Perplexity AI, enabling you to harness this structured data for your own purposes.

Generating Tables with Perplexity AI¶

Perplexity AI offers multiple pathways for generating tables, providing flexibility and catering to diverse user requirements. You can directly instruct Perplexity AI to conduct a search and subsequently organize the retrieved data or search results into a table format. This is particularly useful when you need to compare specific data points across different sources or when you are looking for structured information on a particular topic. The AI’s ability to synthesize information and present it in a tabular format saves considerable time and effort compared to manually compiling data from multiple search results.

For instance, consider a scenario where you are interested in the schedule of Indian events at the 2024 Olympics on August 6^th. By prompting Perplexity AI with a query like, “I need a table of all the India events at the Olympics 2024 on the 6^th of August,” the AI intelligently processes your request. It then searches through relevant databases and web sources to compile the information and presents it to you as a well-structured table. This table would likely include details such as the event name, time, participating athletes (if available), and potentially the venue or competition stage. This direct approach allows you to quickly obtain precisely formatted data without navigating through numerous web pages and manually extracting information.

Furthermore, Perplexity AI’s table generation extends beyond simple searches. It also empowers you to structure data contained within existing articles or documents into a table. This is incredibly beneficial when you have a lengthy document or PDF filled with information that would be more digestible and analyzable in a tabular format. You can upload a PDF document to Perplexity AI and then instruct it to “Arrange the data in this as a table.” The AI will then analyze the document’s content, identify relevant data points, and organize them into a coherent table. This feature is especially valuable for researchers, analysts, and anyone who frequently works with large documents and needs to extract and structure data efficiently.

It is important to note that Perplexity AI Pro subscribers enjoy enhanced capabilities, including the ability to upload larger documents. With a Pro subscription, you can upload documents containing between 25,000 to 30,000 words, assuming the document’s token count remains within the model’s limit of 32k tokens. This expanded capacity makes Perplexity AI Pro an even more powerful tool for professionals who deal with extensive reports, research papers, or other large documents.

In summary, Perplexity AI provides two primary methods for table generation: creating tables directly from search queries and structuring data from user-provided sources like PDF documents. Both methods offer significant advantages in terms of efficiency and data organization, making Perplexity AI a versatile tool for information retrieval and data analysis.

Copying Tables from Perplexity AI¶

Once Perplexity AI has generated a table for you, copying it for use in other applications is a remarkably simple process, requiring just a few straightforward steps. This seamless copy functionality ensures that you can easily integrate the structured data provided by Perplexity AI into your documents, spreadsheets, presentations, or any other platform where you need to utilize the information. The ease of copying tables is a testament to Perplexity AI’s user-centric design, prioritizing efficiency and usability.

Here is a step-by-step guide on how to copy a table from Perplexity AI:

1. Initiate a Search and Request a Table: Begin by accessing Perplexity.AI in your web browser and formulating your search query. To ensure the results are presented in a table, explicitly include a phrase like “in a table” or “format this in a table” within your search query. This instruction guides Perplexity AI to structure the output as a table, making it readily copyable. For example, you might search for “compare the features of the top three smartphones in a table.”

2. Identify the Table in the Search Results: After submitting your query, Perplexity AI will process your request and display the search results. Locate the table generated by Perplexity AI within the search results page. It will typically be clearly demarcated as a table, with rows and columns organizing the information in a structured manner.

3. Select the Table Content: To copy the table, position your mouse cursor in an empty area immediately adjacent to the table. Then, press and hold the left mouse button and drag the cursor diagonally across the table’s content. As you drag, the table’s cells and text will become highlighted, indicating that they are being selected for copying. Ensure that you select the entire table, including all rows and columns, to capture all the data.

4. Copy the Selected Table: Once the table is fully highlighted, you have two primary methods for copying it:

   • Keyboard Shortcut: The quickest method is to use the keyboard shortcut Ctrl+C (on Windows) or Cmd+C (on macOS). Pressing these keys simultaneously will copy the selected table content to your system’s clipboard.

   • Context Menu: Alternatively, you can right-click anywhere within the highlighted table area. This action will open a context menu. From the context menu options, select “Copy”. This command will also copy the selected table content to your clipboard.

5. Paste the Table: With the table content now copied to your clipboard, you can paste it into your desired destination application. This could be a word processing document (like Microsoft Word or Google Docs), a spreadsheet program (like Microsoft Excel or Google Sheets), a presentation software (like PowerPoint or Google Slides), or even a simple text editor. To paste, navigate to your target application, position your cursor where you want to insert the table, and then use the keyboard shortcut Ctrl+V (Windows) or Cmd+V (macOS), or right-click and select “Paste” from the context menu.

In addition to the standard copy-paste methods, Perplexity AI also supports a convenient drag-and-drop functionality for tables, offering an even faster way to transfer table data to certain applications. You can select the table as described in step 3, and instead of copying, simply click and hold on the selected table. Then, drag the table directly into an open document in applications like Word, Excel, Google Docs, or Google Sheets. Upon releasing the mouse button, the table will be inserted into the target document. This drag-and-drop method can be particularly efficient when working with these commonly used office applications.

By following these simple steps, you can effortlessly copy tables generated by Perplexity AI and seamlessly integrate them into your workflow, enhancing your productivity and data utilization capabilities.

Perplexity AI Pro Answer Limits¶

Perplexity AI offers a tiered approach to accessing its advanced features, including “Pro Answers,” which are designed to provide more detailed and segmented responses to complex queries. Understanding the limits associated with Pro Answers is important for users, especially those relying on the free tier of Perplexity AI.

On the free version of Perplexity AI, users are granted five free Pro Answers every day. This daily quota allows users to experience the enhanced capabilities of Pro Answers without requiring a paid subscription. Each time you initiate a search that utilizes the Pro Answer feature, it will deduct one from your available daily quota.

Furthermore, it is crucial to understand that follow-up questions related to a Pro Answer also count against your daily quota, if the Pro Answer feature remains enabled. If you continue to engage with a Pro Answer thread and ask subsequent questions that benefit from the Pro Answer’s enhanced processing, each of these follow-up queries will also be deducted from your remaining free Pro Answer allowance. This mechanism ensures that the limited free quota is managed effectively and encourages users to consider a Pro subscription for more extensive use of the advanced features.

The Pro Answer feature is engineered to provide more in-depth and nuanced responses by segmenting the steps required to address your questions. This often results in answers that are significantly more detailed and comprehensive compared to standard search results. Pro Answers are particularly beneficial for complex inquiries that require multi-faceted analysis or in-depth exploration of a topic. By utilizing the Pro Answer feature judiciously within the free daily quota, users can leverage the power of enhanced AI-driven search without immediately committing to a paid subscription. However, for users who frequently require detailed and comprehensive answers or anticipate exceeding the daily limit, upgrading to Perplexity AI Pro offers unlimited access to Pro Answers and other premium features.

Uploading Spreadsheets to Perplexity AI¶

Perplexity AI’s versatility extends to handling various document types, including spreadsheets, albeit with a necessary intermediary step. While you cannot directly upload spreadsheet files (like .xls or .xlsx) to Perplexity AI, you can readily utilize spreadsheet data by converting it into a Portable Document Format (PDF) file. This conversion enables you to leverage Perplexity AI’s document analysis capabilities with your spreadsheet data.

The process involves two primary steps:

1. Export or Convert Spreadsheets to PDF: First, you need to export your spreadsheet file as a PDF. Most spreadsheet applications, such as Microsoft Excel, Google Sheets, and LibreOffice Calc, provide a built-in “Export to PDF” or “Save As PDF” option. Locate this option within your spreadsheet application’s “File” menu. Select it and save your spreadsheet as a PDF file. Alternatively, if your spreadsheet application lacks a direct PDF export feature, numerous online tools are available that can convert spreadsheet files to PDF format. Simply search for “spreadsheet to PDF converter” online, and you will find a range of free and user-friendly online conversion tools.

2. Upload the PDF to Perplexity AI: Once you have converted your spreadsheet to a PDF file, you can upload it to Perplexity AI. The upload functionality is typically accessible within the Perplexity AI interface, often indicated by an “Upload” button or icon. Click on the upload option and select the PDF file you created from your spreadsheet. Perplexity AI will then process the uploaded PDF document, analyzing its content.

After uploading the spreadsheet as a PDF, you can interact with Perplexity AI to ask various questions related to the data contained within the spreadsheet. For example, you can ask Perplexity AI to summarize the data, identify trends, calculate totals or averages, or extract specific information from the spreadsheet. Perplexity AI’s natural language processing capabilities allow you to formulate your questions in plain English, making it easy to analyze and gain insights from your spreadsheet data without needing to manually sift through rows and columns. This capability is particularly useful for quickly extracting key information, performing high-level analysis, and gaining a comprehensive overview of spreadsheet data using the power of AI.

We hope this guide has clarified the process of generating and copying tables from Perplexity AI, as well as provided useful insights into its Pro Answer features and spreadsheet handling capabilities. Experiment with these techniques and discover how Perplexity AI can streamline your information gathering and data analysis tasks.

Do you find the table copying feature in Perplexity AI helpful? Share your experiences and any tips you might have in the comments below!