Easily Copy and Paste ChatGPT Tables to Google Sheets or Excel

Use the simple tool below to reformat tables from ChatGPT in a way that allows you to copy and paste it back into Excel or Google Sheets. Simply paste the output from ChatGPT into the field below and click the button to generate the result.

Make sure to remove any lines of text that could appear at the beginning of the table.

| Country | Population (millions) | GDP (trillion USD) | Size of Land Mass (sq km) | |----------|-----------------------|--------------------|---------------------------| | Brazil | 213.99 | 2.449 | 8,515,767 | | USA | 331.00 | 21.43 | 9,525,067 | | England | 56.29 | 2.855 | 130,279 | Convert to a nice format for Google Sheets or Excel Copy to Clipboard

Format ChatGPT tables with this simple tool

Are you trying to copy a table from ChatGPT into Google Sheets or Microsoft Excel and ending up with something that looks like this:

If so, this tool is the perfect solution. Simply copy the output from ChatGPT into the field at the top of the page and click the ‘convert’ button. The re-formatted table will be generated below. You can either highlight it manually and copy, or click the ‘copy’ button. Then head over to your spreadsheet tool and copy it into the cell you want, it’s that easy!

I hope you find the tool useful!

ChatGPT Table Format: Pipe-Delimited Tables

ChatGPT tables look something like this:

This format is called a pipe-delimited table. It uses vertical bars (pipes) to separate columns and hyphens to denote column headers and row dividers. Each row represents a record, and each cell within a row contains specific data.

Usage and Advantages

Pipe-delimited tables are easy to read and write in plain text, making them a popular choice for formatting data within web page content. They provide a structured layout for presenting information in a clean and organised manner, making it especially useful for conveying tabular data in documentation, tutorials, and technical articles.

Why They Can’t Be Directly Copied into Google Sheets

While pipe-delimited tables are suitable for displaying data on web pages, they cannot be directly copied and pasted into Google Sheets as they use a different formatting structure. Google Sheets expects data to be organised in a tabular format with cells separated by tabs or commas and rows separated by line breaks.

Attempting to paste a pipe-delimited table directly into Google Sheets may result in a single cell containing all the data, rendering it unreadable and unmanageable. Fortunately, this tool will help you to easily copy and paste data into Google Sheets or any other spreadsheet software.

Table Formats Compatible with Google Sheets

To successfully copy data into Google Sheets, use one of the following formats:

1. Comma-Delimited (CSV): In this format, columns are separated by commas, and rows are separated by line breaks. It’s the most widely recognized format for importing data into spreadsheets.
2. Tab-Delimited: Similar to CSV, but columns are separated by tabs instead of commas. This format is suitable for pasting data directly from a text editor or table generator. This is the format outputted by the tool above.
3. HTML Tables: If you’re copying data from a web page, you can often copy and paste an HTML table directly into Google Sheets, preserving its structure.