Convert Credit Card Bill to Spreadsheet Prompt

Promote your AIPRM Prompt
1

## Link to Prompt:

link to Prompt "Convert Credit Card Bill to Spreadsheet" by "Milena Johnston" - AIPRM for ChatGPT

## What the Prompt does:

  • The prompt “Convert Your Credit Card Bill into a Table for Excel/Google Sheets” allows users to easily transform a credit card bill in plain text format (such as PDF) into a table format to use in Excel or Google Sheets.
  • It automates the process of converting a credit card bill into a formatted table, saving time and effort for the users.
  • The prompt removes spaces in establishment names and merges them, as well as separates the columns of the text into a table format.

## Example Prompt Output GPT3.5

Input:
Date Establishment Amount
01/05/2023 RestaurantXYZ $50,00
02/05/2023 StoreABC $25,00
03/05/2023 GasStation $40,00

Output:

Date Establishment Amount
01/05/2023 Restaurant XYZ $50.00
02/05/2023 Store ABC $25.00
03/05/2023 Gas Station $40.00

## Example Prompt Output GPT4

Input:
Date Establishment Amount
01/05/2023 RestaurantXYZ $50,00
02/05/2023 StoreABC $25,00
03/05/2023 GasStation $40,00

Output:

Date Establishment Amount
01/05/2023 Restaurant XYZ $50.00
02/05/2023 Store ABC $25.00
03/05/2023 Gas Station $40.00

## How I came up with it

I created this prompt based on the user’s request to convert a credit card bill into a table for Excel/Google Sheets. I formulated the description and instructions to provide a clear understanding of the prompt’s purpose and usage.

## More insights

  • The prompt was designed to solve the problem of converting a credit card bill in plain text format into a table format suitable for Excel or Google Sheets.
  • The output demonstrates the effectiveness of the prompt by showing an example of the transformed text into a formatted table.
  • As per the user’s request, providing a screenshot is not necessary since the text-based output is more practical and searchable.
1 Like