Member-only story
Using ChatGPT to create a spreadsheet
I’ve been exploring ways to use ChatGPT for various applications recently. There’s already been a lot of talk about how it helps write emails, create summaries for documents and even write the code for website. I’ve actually used it for all of these.
One of the new ways I’ve been trying it, is by getting it to create comma separated entries from a food and drink guidebook into a format used for a spreadsheet.
I then intended to take the spreadsheet and use it create a JSON file and then ultimately to make an API.
For now then, I’ll stick with the transposition.
The bonus is that you can use the 3.5 version of the AI model.
First, I give ChatGPT a role:
Can you act as a data entry expert and transpose some data for me? I will give you some text in the following format. Please write in English language.
Reply: Yes, I can certainly help with transposing data for you. Please provide me with the text that needs to be transposed and any instructions or formatting requirements you may have.
Prompt:
The format is as follows: first line is the [restaurant name], the second is [address], the address is [phone number]/[URL], fourth line is the [description]. Any line that starts with the…
